/*
 Navicat Premium Data Transfer

 Source Server         : Local MySql
 Source Server Type    : MySQL
 Source Server Version : 50525
 Source Host           : localhost
 Source Database       : Farmacityweb

 Target Server Type    : MySQL
 Target Server Version : 50525
 File Encoding         : utf-8

 Date: 08/09/2012 13:53:31 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `nuvrj_jtec_events`
-- ----------------------------
DROP TABLE IF EXISTS `nuvrj_jtec_events`;
CREATE TABLE `nuvrj_jtec_events` (
  `eventId` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `eventCalendarId` mediumint(8) unsigned NOT NULL,
  `eventParentId` int(11) unsigned DEFAULT '0',
  `eventUserId` int(11) unsigned NOT NULL,
  `eventTitle` varchar(255) NOT NULL,
  `eventLocation` varchar(255) DEFAULT NULL,
  `eventNotes` text,
  `eventNotesHTML` text,
  `eventAlertPeriod` smallint(5) unsigned DEFAULT NULL,
  `eventAlertPeriodType` enum('hour','day') DEFAULT 'hour',
  `eventAlertTime` datetime DEFAULT NULL,
  `eventStartTime` datetime NOT NULL,
  `eventEndTime` datetime NOT NULL,
  `eventInfoLink` varchar(255) DEFAULT NULL,
  `eventRepeatSchema` text,
  `eventRepeatEndDate` datetime DEFAULT NULL,
  `eventAllDay` tinyint(1) unsigned zerofill NOT NULL DEFAULT '0',
  `eventIsPublic` tinyint(1) unsigned zerofill NOT NULL DEFAULT '0',
  `eventHasComments` tinyint(1) unsigned zerofill NOT NULL DEFAULT '1',
  `eventInviteOnly` tinyint(1) unsigned zerofill NOT NULL DEFAULT '0',
  `eventCreatedAt` datetime NOT NULL,
  `eventDeletedAt` datetime DEFAULT NULL,
  PRIMARY KEY (`eventId`),
  KEY `eventCalendarId` (`eventCalendarId`,`eventParentId`,`eventUserId`,`eventTitle`,`eventAlertTime`,`eventStartTime`,`eventEndTime`,`eventIsPublic`,`eventHasComments`,`eventInviteOnly`,`eventCreatedAt`,`eventDeletedAt`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `nuvrj_jtec_events`
-- ----------------------------
BEGIN;
INSERT INTO `nuvrj_jtec_events` VALUES ('2', '2', '0', '43', '16.00 - 19.00', '', '', '', '0', 'hour', null, '2012-08-07 16:00:00', '2012-08-07 19:00:00', '', 'never', null, '0', '0', '0', '0', '2012-08-07 10:56:59', null);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
